package cn.easy.kitchen.repository;

import cn.easy.kitchen.domain.Bom;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;

public interface BomDao extends PagingAndSortingRepository<Bom, String>, JpaSpecificationExecutor<Bom> {
    
    @Query("SELECT count(DISTINCT destMaterialId) FROM Bom ")
    int countBom();
}
